package com.zyg.controller;

import com.alibaba.fastjson2.JSON;
import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.zyg.pojo.Stu;
import com.zyg.service.StuService;
import com.zyg.util.LayData;
import jakarta.annotation.Resource;
import org.springframework.stereotype.Controller;
import org.springframework.ui.Model;
import org.springframework.web.bind.annotation.PathVariable;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestParam;
import org.springframework.web.bind.annotation.ResponseBody;

import java.util.List;

@Controller
@RequestMapping("/stu")
public class StuController {


    @Resource
    private StuService stuService;

    @RequestMapping("/tolist")
    public  String tolist(){
        return "stu/list";
    }


    @RequestMapping("/list")
    @ResponseBody
    public  String list(Stu stu, @RequestParam(value = "page", defaultValue = "1") Integer page, @RequestParam(value = "limit", defaultValue = "10") Integer limit){
        // 查询数据
        LayData layData = new LayData();

        QueryWrapper<Stu> qw = new QueryWrapper<>();

        qw.like(stu.getStuName()!=null && !"".equals(stu.getStuName()),"stu_name",stu.getStuName());

        long count = stuService.count(qw);
        layData.setCount((int) count);
        IPage<Stu> page1 = new Page<>(page, limit);
        List<Stu> list = stuService.list(page1, qw);
        layData.setData(list);


        layData.setCode(0);
        layData.setMsg("查询成功");
// 数据返回
        String data = JSON.toJSONString(layData);

        return data;
    }

    @RequestMapping("/toadd")
    public String toAdd(){
        return "stu/add";
    }

    @RequestMapping("/addSave")
    @ResponseBody
    public String addSave(Stu stu){
        boolean result = stuService.save(stu);
        if (result) {
            return JSON.toJSONString(new LayData(0, "添加成功"));
        } else {
            return JSON.toJSONString(new LayData(500, "添加失败"));
        }
    }

    @RequestMapping("/toupdate/{id}")
    public String toUpdate(@PathVariable("id") int id, Model model){
        Stu stu = stuService.getById(id);
        model.addAttribute("stu", stu);
        return "stu/update";
    }

    @RequestMapping("/toinfo/{id}")
    public String toInfo(@PathVariable("id") int id, Model model){
        Stu stu = stuService.getById(id);
        model.addAttribute("stu", stu);
        return "stu/info";
    }

    @RequestMapping("/updateSave")
    @ResponseBody
    public String updateSave(Stu stu){
        boolean result = stuService.updateById(stu);
        if (result) {
            return JSON.toJSONString(new LayData(0, "更新成功"));
        } else {
            return JSON.toJSONString(new LayData(500, "更新失败"));
        }
    }

    @RequestMapping("/delete/{id}")
    @ResponseBody
    public String deleteStu(@PathVariable("id") int id){
        boolean result = stuService.removeById(id);
        if (result) {
            return JSON.toJSONString(new LayData(0, "删除成功"));
        } else {
            return JSON.toJSONString(new LayData(500, "删除失败"));
        }
    }


}